package com.hpe.mapper;

import com.hpe.entity.Manager;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

public interface ManagerMapper {
    //根据用户名和密码查询单条数据
    @Select("SELECT id,username,password FROM bms_manager WHERE username=#{user} AND password=#{pwd}")
    Manager selectManager(@Param("user") String user,@Param("pwd") String pwd);

    //修改密码
    @Update("UPDATE bms_manager SET password=#{pwd} WHERE username=#{user}")
    void updatePassWord(@Param("user") String user,@Param("pwd") String pwd);
}
